[code bundle from] Microsoft Dynamics AX 2012 Development Cookbook

Cover\r......Page 1
Copyright......Page 3
Credits......Page 4
About the Author......Page 5
About the Reviewers......Page 6
www.PacktPub.com......Page 7
Table of Contents......Page 8
Preface......Page 12
Introduction......Page 18
Creating a new number sequence......Page 19
Renaming the primary key......Page 24
Merging two records......Page 28
Adding a document handling note......Page 30
Using a normal table as a temporary table......Page 32
Copying a record......Page 33
Building a query object......Page 36
Using a macro in an SQL statement......Page 41
Executing a direct SQL statement......Page 42
Enhancing the data consistency check......Page 48
Exporting data to an XML file......Page 52
Importing data from an XML file......Page 55
Creating a comma separated value file......Page 57
Reading a comma-separated value file......Page 60
Using the date effectiveness feature......Page 63
Introduction......Page 68
Creating a dialog......Page 69
Handling a dialog event......Page 74
Building a dynamic form......Page 78
Adding a form splitter......Page 83
Creating a modal form......Page 88
Modifying multiple forms dynamically......Page 90
Storing last form values......Page 93
Using a tree control......Page 96
Building a checklist......Page 108
Adding the View details link......Page 116
Introduction......Page 120
Using a number sequence handler......Page 121
Creating a custom filter......Page 124
Creating a custom instant search filter......Page 128
Building a selected/available list......Page 131
Preloading images......Page 138
Creating a wizard......Page 145
Processing multiple records......Page 155
Coloring records......Page 157
Adding an image to records......Page 158
Introduction......Page 168
Creating an automatic lookup......Page 169
Creating a lookup dynamically......Page 172
Using a form for building a lookup......Page 174
Building a tree lookup......Page 180
Displaying a list of custom options......Page 184
Another way of displaying custom options......Page 186
Building a lookup based on record description......Page 190
Building the Browse for Folder lookup......Page 196
Building a lookup for selecting a file......Page 201
Creating a color picker lookup......Page 205
Introduction......Page 212
Using a segmented entry control......Page 213
Creating a general journal......Page 218
Posting a general journal......Page 226
Processing a project journal......Page 228
Creating and posting a ledger voucher......Page 232
Changing an automatic transaction text......Page 236
Creating a purchase order......Page 239
Posting a purchase order......Page 242
Creating a sales order......Page 247
Posting a sales order......Page 250
Creating an electronic payment format......Page 254
Introduction......Page 264
Creating an Excel file......Page 265
Reading an Excel file......Page 267
Creating a Word document from a template......Page 270
Creating a Word document with repeating elements......Page 273
Creating a Microsoft Project file......Page 277
Sending an e-mail using Outlook......Page 282
Introduction......Page 286
Consuming the system query service......Page 287
Consuming the system metadata service......Page 290
Consuming an existing document service......Page 292
Creating a document service......Page 296
Consuming a document service......Page 301
Using an enhanced document service......Page 303
Creating a custom service......Page 309
Consuming a custom service......Page 312
Consuming an external service......Page 314
Introduction......Page 320
Creating an editor template......Page 321
Modifying the Tools menu......Page 326
Modifying the right-click context menu......Page 328
Searching for an object in a development project......Page 333
Modifying the Personalization form......Page 336
Modifying the application version......Page 340
Introduction......Page 344
Calculating code execution time......Page 345
Writing efficient SQL statements......Page 347
Caching a display method......Page 349
Using Dynamics AX Trace Parser......Page 352
Using SQL Server Database Engine Tuning Advisor......Page 356
Index......Page 360